--------------------------------------------------------
--  File created - Wednesday-December-30-2015   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table ACCOUNT
--------------------------------------------------------

  CREATE TABLE "ACCOUNT" 
   (	"APPLICATION_KEY" VARCHAR2(36 BYTE), 
	"USER_NAME" VARCHAR2(128 BYTE), 
	"PASSWORD" VARCHAR2(128 BYTE), 
	"ACTIVE" VARCHAR2(1 BYTE), 
	"CREATE_DATE" DATE, 
	"UPDATE_DATE" DATE, 
	"GROUP_ID" VARCHAR2(36 BYTE)
   ) ;
--------------------------------------------------------
--  DDL for Table ACCOUNT_INFO
--------------------------------------------------------

  CREATE TABLE "ACCOUNT_INFO" 
   (	"APPLICATION_KEY" VARCHAR2(36 BYTE), 
	"USER_NAME" VARCHAR2(256 BYTE), 
	"FIRST_NAME" VARCHAR2(128 BYTE), 
	"LAST_NAME" VARCHAR2(128 BYTE), 
	"MOBILE_ALIAS" VARCHAR2(16 BYTE), 
	"MOBILE_PIN" VARCHAR2(16 BYTE), 
	"EMAIL" VARCHAR2(256 BYTE), 
	"IS_ANONYMOUS" VARCHAR2(1 BYTE), 
	"IS_APPROVED" VARCHAR2(1 BYTE), 
	"IS_LOCKEDOUT" VARCHAR2(1 BYTE), 
	"CREATE_UTC_DATE" DATE, 
	"FAILED_PASSWORD_ATTEMPT_COUNT" NUMBER(*,0), 
	"FAILED_PASSWORD_ATTEMPT_DATE" DATE, 
	"FAILED_ANSWER_ATTEMPT_COUNT" NUMBER(*,0), 
	"FAILED_ANSWER_ATTEMPT_DATE" DATE, 
	"PASSWORD_EXPIRATION_UTC_DATE" DATE, 
	"IS_DELETED" VARCHAR2(1 BYTE), 
	"CAN_CONTACT_BY_EMAIL" VARCHAR2(1 BYTE), 
	"IS_SUSPENDED" VARCHAR2(1 BYTE), 
	"LAST_PASSWORD_CHANGED_DATE" DATE, 
	"IMAGE_URL" VARCHAR2(250 BYTE), 
	"BIRTHDAY" DATE, 
	"ADDRESS" VARCHAR2(250 BYTE), 
	"GENDER" VARCHAR2(20 BYTE)
   );
--------------------------------------------------------
--  DDL for Table ACCOUNT_LOGON_AUDIT
--------------------------------------------------------

  CREATE TABLE "ACCOUNT_LOGON_AUDIT" 
   (	"APPLICATION_KEY" VARCHAR2(36 BYTE), 
	"ID" NUMBER, 
	"CLIENT_USER_NAME" VARCHAR2(50 BYTE), 
	"CLIENT_MACHINE_NAME" VARCHAR2(128 BYTE), 
	"CLIENT_IP_ADDRESS" VARCHAR2(11 BYTE), 
	"USER_NAME" VARCHAR2(20 BYTE), 
	"FULLNAME_ENGLISH" VARCHAR2(128 BYTE), 
	"CREATION_DATE" DATE
   );
--------------------------------------------------------
--  DDL for Table ACCOUNT_PASSWORD_AUDIT
--------------------------------------------------------

  CREATE TABLE "ACCOUNT_PASSWORD_AUDIT" 
   (	"APPLICATION_KEY" VARCHAR2(36 BYTE), 
	"ID" VARCHAR2(5 BYTE), 
	"USER_NAME" VARCHAR2(50 BYTE), 
	"PASSWORD" VARCHAR2(128 BYTE), 
	"CREATION_DATE" DATE, 
	"ACTIVE" CHAR(1 BYTE)
   )  ;
--------------------------------------------------------
--  DDL for Table APPLICATION
--------------------------------------------------------

  CREATE TABLE "APPLICATION" 
   (	"APPLICATION_KEY" VARCHAR2(36 BYTE), 
	"NAME" VARCHAR2(256 BYTE), 
	"CREATED_UTC" DATE, 
	"MODIFIED_UTC_DATE" DATE, 
	"DESCRIPTION" VARCHAR2(256 BYTE)
   ) ;

   COMMENT ON COLUMN "APPLICATION"."APPLICATION_KEY" IS 'Application key (guid)';
   COMMENT ON COLUMN "APPLICATION"."NAME" IS 'Application name';
   COMMENT ON COLUMN "APPLICATION"."CREATED_UTC" IS 'Created date';
   COMMENT ON COLUMN "APPLICATION"."MODIFIED_UTC_DATE" IS 'Modified date';
   COMMENT ON COLUMN "APPLICATION"."DESCRIPTION" IS 'Descriptipn';
--------------------------------------------------------
--  DDL for Table APPLICATION_ACCOUNT_RULE
--------------------------------------------------------

  CREATE TABLE "APPLICATION_ACCOUNT_RULE" 
   (	"APPLICATION_KEY" VARCHAR2(36 BYTE), 
	"USER_NAME" VARCHAR2(50 BYTE), 
	"OBJECT_ID" VARCHAR2(50 BYTE), 
	"RULE_ID" VARCHAR2(20 BYTE), 
	"ACTIVE" CHAR(1 BYTE)
   ) ;
--------------------------------------------------------
--  DDL for Table APPLICATION_GROUP
--------------------------------------------------------

  CREATE TABLE "APPLICATION_GROUP" 
   (	"APPLICATION_KEY" VARCHAR2(36 BYTE), 
	"GROUP_ID" VARCHAR2(36 BYTE), 
	"GROUP_NAME_LOCAL" VARCHAR2(100 BYTE), 
	"GROUP_NAME_ENGLISH" VARCHAR2(100 BYTE), 
	"DESCRIPTION" VARCHAR2(200 BYTE), 
	"ACTIVE" VARCHAR2(1 BYTE)
   ) ;
--------------------------------------------------------
--  DDL for Table APPLICATION_GROUP_RULE
--------------------------------------------------------

  CREATE TABLE "APPLICATION_GROUP_RULE" 
   (	"APPLICATION_KEY" VARCHAR2(36 BYTE), 
	"GROUP_ID" VARCHAR2(50 BYTE), 
	"OBJECT_ID" VARCHAR2(50 BYTE), 
	"RULE_ID" VARCHAR2(20 BYTE), 
	"ACTIVE" CHAR(1 BYTE)
   ) ;
--------------------------------------------------------
--  DDL for Table APPLICATION_OBJECT
--------------------------------------------------------

  CREATE TABLE "APPLICATION_OBJECT" 
   (	"APPLICATION_KEY" VARCHAR2(36 BYTE), 
	"ID" VARCHAR2(32 BYTE), 
	"OBJECT_URL" VARCHAR2(250 BYTE), 
	"OBJECT_ICON_URL" VARCHAR2(250 BYTE), 
	"OBJECT_NAME_LOCAL" VARCHAR2(100 BYTE), 
	"OBJECT_NAME_ENGLISH" VARCHAR2(100 BYTE), 
	"PARENT_ID" VARCHAR2(32 BYTE), 
	"OLEVEL" NUMBER, 
	"ORDER_ID" NUMBER, 
	"ACTIVE" VARCHAR2(1 BYTE)
   )  ;
--------------------------------------------------------
--  DDL for Table APPLICATION_RULE
--------------------------------------------------------

  CREATE TABLE "APPLICATION_RULE" 
   (	"APPLICATION_KEY" VARCHAR2(36 BYTE), 
	"RULE_ID" NUMBER(8,0), 
	"RULE_NAME_LOCAL" VARCHAR2(100 BYTE), 
	"RULE_NAME_ENGLISH" VARCHAR2(100 BYTE), 
	"DESCRIPTION" VARCHAR2(255 BYTE), 
	"ACTIVE" VARCHAR2(1 BYTE)
   ) ;

   COMMENT ON COLUMN "APPLICATION_RULE"."RULE_ID" IS 'RULE ID. TYPE GEST';
   COMMENT ON COLUMN "APPLICATION_RULE"."RULE_NAME_LOCAL" IS 'LOCAL NAME OF RULE';
   COMMENT ON COLUMN "APPLICATION_RULE"."RULE_NAME_ENGLISH" IS 'ENGLISH NAME OF RULE';
   COMMENT ON COLUMN "APPLICATION_RULE"."ACTIVE" IS 'Y/N TYPE OF ACTIVE RULE';
--------------------------------------------------------
--  DDL for Table DICTIONARY
--------------------------------------------------------

  CREATE TABLE "DICTIONARY" 
   (	"APPLICATION_KEY" VARCHAR2(36 BYTE), 
	"KEY" VARCHAR2(128 BYTE), 
	"VALUE" VARCHAR2(256 BYTE), 
	"CREATION_DATE" DATE, 
	"UPDATE_DATE" DATE
   ) ;
--------------------------------------------------------
--  DDL for Table DIR_LIST
--------------------------------------------------------

  CREATE GLOBAL TEMPORARY TABLE "DIR_LIST" 
   (	"FILENAME" VARCHAR2(1024 BYTE)
   ) ON COMMIT DELETE ROWS ;
--------------------------------------------------------
--  DDL for Table OBJECT_SUBSTITUTION
--------------------------------------------------------

  CREATE TABLE "OBJECT_SUBSTITUTION" 
   (	"APPLICATION_KEY" VARCHAR2(36 BYTE), 
	"ID" VARCHAR2(32 BYTE), 
	"OBJECT_ID" VARCHAR2(32 BYTE), 
	"OBJECT_NAME_LOCAL" VARCHAR2(100 BYTE), 
	"OBJECT_NAME_ENGLISH" VARCHAR2(100 BYTE), 
	"PARENT_ID" VARCHAR2(32 BYTE), 
	"OLEVEL" NUMBER, 
	"ORDER_ID" NUMBER, 
	"ACTIVE" VARCHAR2(1 BYTE)
   )  ;
REM INSERTING into WSOM.ACCOUNT
SET DEFINE OFF;
Insert into WSOM.ACCOUNT (APPLICATION_KEY,USER_NAME,PASSWORD,ACTIVE,CREATE_DATE,UPDATE_DATE,GROUP_ID) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','andrew','941c8bba431c0b58926397c7accf7e37b3f1a58b9651892e52915867de74ead8','Y',to_date('18-DEC-15','DD-MON-RR'),null,'1');
Insert into WSOM.ACCOUNT (APPLICATION_KEY,USER_NAME,PASSWORD,ACTIVE,CREATE_DATE,UPDATE_DATE,GROUP_ID) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','VN101645','6e0d2c260bdf03574acd06b5c08f59e297ef4d9229fdd919fcbe93bccf239be0','Y',to_date('13-DEC-15','DD-MON-RR'),null,'1');
Insert into WSOM.ACCOUNT (APPLICATION_KEY,USER_NAME,PASSWORD,ACTIVE,CREATE_DATE,UPDATE_DATE,GROUP_ID) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','SYSADMIN','e03f4663da577be11bf0e00262b6e7396c70955690959877f39388d7a51541e8','Y',to_date('15-DEC-15','DD-MON-RR'),null,'1');
REM INSERTING into WSOM.ACCOUNT_INFO
SET DEFINE OFF;
Insert into WSOM.ACCOUNT_INFO (APPLICATION_KEY,USER_NAME,FIRST_NAME,LAST_NAME,MOBILE_ALIAS,MOBILE_PIN,EMAIL,IS_ANONYMOUS,IS_APPROVED,IS_LOCKEDOUT,CREATE_UTC_DATE,FAILED_PASSWORD_ATTEMPT_COUNT,FAILED_PASSWORD_ATTEMPT_DATE,FAILED_ANSWER_ATTEMPT_COUNT,FAILED_ANSWER_ATTEMPT_DATE,PASSWORD_EXPIRATION_UTC_DATE,IS_DELETED,CAN_CONTACT_BY_EMAIL,IS_SUSPENDED,LAST_PASSWORD_CHANGED_DATE,IMAGE_URL,BIRTHDAY,ADDRESS,GENDER) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','andrew','Andrew','Nguyen',null,'0902216432','andrew.nguyen@istech.com','N','Y','Y',to_date('15-MAY-01','DD-MON-RR'),0,to_date('01-JAN-01','DD-MON-RR'),0,to_date('01-JAN-01','DD-MON-RR'),null,'N',null,'N',null,null,to_date('23-DEC-15','DD-MON-RR'),null,'M');
Insert into WSOM.ACCOUNT_INFO (APPLICATION_KEY,USER_NAME,FIRST_NAME,LAST_NAME,MOBILE_ALIAS,MOBILE_PIN,EMAIL,IS_ANONYMOUS,IS_APPROVED,IS_LOCKEDOUT,CREATE_UTC_DATE,FAILED_PASSWORD_ATTEMPT_COUNT,FAILED_PASSWORD_ATTEMPT_DATE,FAILED_ANSWER_ATTEMPT_COUNT,FAILED_ANSWER_ATTEMPT_DATE,PASSWORD_EXPIRATION_UTC_DATE,IS_DELETED,CAN_CONTACT_BY_EMAIL,IS_SUSPENDED,LAST_PASSWORD_CHANGED_DATE,IMAGE_URL,BIRTHDAY,ADDRESS,GENDER) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','SYSADMIN','System','Admin',null,'0902216432','kiemhieu@gmail.com','N','Y','Y',to_date('21-JAN-85','DD-MON-RR'),0,to_date('01-JAN-01','DD-MON-RR'),0,to_date('01-JAN-01','DD-MON-RR'),null,'N',null,'N',null,null,to_date('23-DEC-15','DD-MON-RR'),null,'F');
REM INSERTING into WSOM.ACCOUNT_LOGON_AUDIT
SET DEFINE OFF;
REM INSERTING into WSOM.ACCOUNT_PASSWORD_AUDIT
SET DEFINE OFF;
REM INSERTING into WSOM.APPLICATION
SET DEFINE OFF;
Insert into WSOM.APPLICATION (APPLICATION_KEY,NAME,CREATED_UTC,MODIFIED_UTC_DATE,DESCRIPTION) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','Waranty & Sale-out manager',null,null,null);
REM INSERTING into WSOM.APPLICATION_ACCOUNT_RULE
SET DEFINE OFF;
REM INSERTING into WSOM.APPLICATION_GROUP
SET DEFINE OFF;
Insert into WSOM.APPLICATION_GROUP (APPLICATION_KEY,GROUP_ID,GROUP_NAME_LOCAL,GROUP_NAME_ENGLISH,DESCRIPTION,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','1','Supper Admin','Supper Admin','Supper Admin','Y');
REM INSERTING into WSOM.APPLICATION_GROUP_RULE
SET DEFINE OFF;
REM INSERTING into WSOM.APPLICATION_OBJECT
SET DEFINE OFF;
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0507','/report/Dependence',null,'Dependences report','Dependences report','05',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0310','/Attendance/UncountOt',null,'OT Uncounted List','OT Uncounted List','03',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0311','/Attendance/UncountOt',null,'OT Uncounted List','OT Uncounted List','03',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0205','/Employee/Details',null,'Detail','Detail','02',1,0,'N');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0312','/Attendance/CloseAttendance',null,'Close attendance','Close attendance','03',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0106','/account/logoff',null,'Logout','Logout','01',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0104','/Account/InUser/',null,'User Functions','User Functions','01',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','010101','/list/code',null,'List code','List code','0101',2,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','010102','/list/paycode',null,'List paycode','List paycode','0101',2,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','010103','/list/insurance',null,'List insurance','List insurance','0101',2,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','010104','/list/pit_level',null,'List PIT level','List PIT level','0101',2,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','010105','/list/grossup',null,'List Gross-up level','List Gross-up level','0101',2,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0102',null,null,'Configuration','Configuration','01',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','010201','/configuration',null,'System configuration','System configuration','0102',2,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','010202','/account/list',null,'Account List','Account List','0102',2,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','010203','/account/group',null,'List group','List group','0102',2,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','010204','/account/setpassword',null,'Set employee password','Set employee password','0102',2,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','010205','/account/setempgroup',null,'Set employee group','Set employee group','0102',2,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','02',null,null,'Employees','Employees',null,0,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0201','/list/division',null,'Division list','Division list','02',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0202','/list/department',null,'Department list','Department list','02',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0203','/employee/list',null,'Employeees','Employeees','02',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0204','/list/dependence',null,'Dependence list','Dependence list','02',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','03',null,null,'Attendance','Attendance',null,0,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0301',null,null,'List code','List code','03',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','030101','/attlist/attcode',null,'Attendance code','Attendance code','0301',2,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','030102','/attlist/otcode',null,'Overtime code','Overtime code','0301',2,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','030103','/attlist/worktimecode',null,'Worktime code','Worktime code','0301',2,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','030104','/attlist/shiftnumber',null,'Shift code','Shift code','0301',2,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','030105','/attendance/calendar',null,'Calendar of Holiday','Calendar of Holiday','0301',2,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0302','/Attendance/InitialDate',null,'Initial date','Initial date','03',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0303','/Attendance/SetEmpShift',null,'Set Employee Shift','Set Employee Shift','03',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0304','/Attendance/ShiftNoSearch',null,'Search Employee Shift','Search Employee Shift','03',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0305','/Attendance/AssignPlanRegister',null,'Assigning to Plan register','Assigning to Plan register','03',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0306','/Attendance/AssignPlanSearch',null,'Search assigned info','Search assigned info','03',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0307',null,null,'Create plan','Create plan','03',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','030701','/Attendance/index/ShiftPlan',null,'Shift plan','Shift plan','0307',2,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','030702','/Attendance/index/EmpPlan',null,'Employee plan','Employee plan','0307',2,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','030703','/Attendance/CheckinDataReg',null,'Checkin register','Checkin register','0307',2,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','030704','/Attendance/index/OtPlan',null,'Overtime plan','Overtime plan','0307',2,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0308',null,null,'Review plan','Review plan','03',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','030801','/Attendance/ReviewEmpPlan',null,'Review employee plan','Review employee plan','0308',2,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','030802','/Attendance/ReviewCheckinData',null,'Review checkin register','Review checkin register','0308',2,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','030803','/Attendance/ReviewOtPlan',null,'Review overtime plan','Review overtime plan','0308',2,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0309','/Attendance/index/Summary',null,'Attendance summary','Attendance summary','03',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','04',null,null,'Payment','Payment',null,0,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0401','/payment/register',null,'Register individual pay','Register individual pay','04',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0402','/payment/individual',null,'ndividual pay list','ndividual pay list','04',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0403','/payment/uncounted',null,'Uncounted list','Uncounted list','04',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0404','/payment/inscalc',null,'Insurance calculated list','Insurance calculated list','04',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0405','/payment/',null,'Payment & history','Payment & history','04',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0406','/payment/calculate',null,'Calculate payment','Calculate payment','04',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0407','/list/currency',null,'Exchange rate','Exchange rate','04',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','05',null,null,'Reporting','Reporting',null,0,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0501','/report/attreport',null,'Attendance Report','Attendance Report','05',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0502','/report/banktransfer',null,'Bank transfer','Bank transfer','05',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0503','/report/paymentsummary',null,'Payment sumary','Payment sumary','05',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0504','/report/paymentinsurance',null,'Insurance monthly report','Insurance monthly report','05',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0505','/report/payment',null,'Payment report','Payment report','05',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0506','/report/pit',null,'PIT report','PIT report','05',1,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','01',null,null,'System','System',null,0,0,'Y');
Insert into WSOM.APPLICATION_OBJECT (APPLICATION_KEY,ID,OBJECT_URL,OBJECT_ICON_URL,OBJECT_NAME_LOCAL,OBJECT_NAME_ENGLISH,PARENT_ID,OLEVEL,ORDER_ID,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83','0101','/system',null,'List of the system','List of the system','01',1,0,'Y');
REM INSERTING into WSOM.APPLICATION_RULE
SET DEFINE OFF;
Insert into WSOM.APPLICATION_RULE (APPLICATION_KEY,RULE_ID,RULE_NAME_LOCAL,RULE_NAME_ENGLISH,DESCRIPTION,ACTIVE) values ('7FACBBAA-1113-4D8D-B37D-F22646771F83',1,'Access','Access','Access to a module role','Y');
REM INSERTING into WSOM.DICTIONARY
SET DEFINE OFF;
Insert into WSOM.DICTIONARY (APPLICATION_KEY,KEY,VALUE,CREATION_DATE,UPDATE_DATE) values ('7facbbaa-1113-4d8d-b37d-f22646771f83','VerifyNumber130952462375387438.jpg','64328',to_date('22-DEC-15','DD-MON-RR'),null);
Insert into WSOM.DICTIONARY (APPLICATION_KEY,KEY,VALUE,CREATION_DATE,UPDATE_DATE) values ('7facbbaa-1113-4d8d-b37d-f22646771f83','VerifyNumber130952463113356677.jpg','87484',to_date('22-DEC-15','DD-MON-RR'),null);
Insert into WSOM.DICTIONARY (APPLICATION_KEY,KEY,VALUE,CREATION_DATE,UPDATE_DATE) values ('7facbbaa-1113-4d8d-b37d-f22646771f83','VerifyNumber130952464098265031.jpg','77895',to_date('22-DEC-15','DD-MON-RR'),null);
Insert into WSOM.DICTIONARY (APPLICATION_KEY,KEY,VALUE,CREATION_DATE,UPDATE_DATE) values ('7facbbaa-1113-4d8d-b37d-f22646771f83','VerifyNumber130952467485600654.jpg','22095',to_date('22-DEC-15','DD-MON-RR'),null);
Insert into WSOM.DICTIONARY (APPLICATION_KEY,KEY,VALUE,CREATION_DATE,UPDATE_DATE) values ('7facbbaa-1113-4d8d-b37d-f22646771f83','VerifyNumber130952548300857780.jpg','55557',to_date('22-DEC-15','DD-MON-RR'),null);
REM INSERTING into WSOM.DIR_LIST
SET DEFINE OFF;
REM INSERTING into WSOM.OBJECT_SUBSTITUTION
SET DEFINE OFF;
--------------------------------------------------------
--  DDL for Index APP_USER_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "APP_USER_PK" ON "ACCOUNT" ("APPLICATION_KEY", "USER_NAME") ;
--------------------------------------------------------
--  DDL for Index ACCOUNT_INFO_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "ACCOUNT_INFO_PK" ON "ACCOUNT_INFO" ("APPLICATION_KEY", "USER_NAME")  ;
--------------------------------------------------------
--  DDL for Index ACCOUNT_PASSWORD_AUDIT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "ACCOUNT_PASSWORD_AUDIT_PK" ON "ACCOUNT_PASSWORD_AUDIT" ("APPLICATION_KEY", "ID", "USER_NAME") ;
--------------------------------------------------------
--  DDL for Index APPLICATION_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "APPLICATION_PK" ON "APPLICATION" ("APPLICATION_KEY") ;
--------------------------------------------------------
--  DDL for Index APPLICATION_ACCOUNT_RULE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "APPLICATION_ACCOUNT_RULE_PK" ON "APPLICATION_ACCOUNT_RULE" ("APPLICATION_KEY", "USER_NAME", "OBJECT_ID", "RULE_ID")  ;
--------------------------------------------------------
--  DDL for Index APPLICATION_GROUP_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "APPLICATION_GROUP_PK" ON "APPLICATION_GROUP" ("APPLICATION_KEY", "GROUP_ID") ;
--------------------------------------------------------
--  DDL for Index APPLICATION_GROUP_RULE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "APPLICATION_GROUP_RULE_PK" ON "APPLICATION_GROUP_RULE" ("APPLICATION_KEY", "GROUP_ID", "OBJECT_ID", "RULE_ID") ;
--------------------------------------------------------
--  DDL for Index APPLICATION_OBJECT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "APPLICATION_OBJECT_PK" ON "APPLICATION_OBJECT" ("APPLICATION_KEY", "ID") ;
--------------------------------------------------------
--  DDL for Index SYS_RULE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_RULE_PK" ON "APPLICATION_RULE" ("APPLICATION_KEY", "RULE_ID") ;
--------------------------------------------------------
--  DDL for Index APPLICATION_RULE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "APPLICATION_RULE_PK" ON "APPLICATION_RULE" ("RULE_ID");
--------------------------------------------------------
--  DDL for Index DICTIONARY_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "DICTIONARY_PK" ON "DICTIONARY" ("APPLICATION_KEY", "KEY") ;
--------------------------------------------------------
--  DDL for Index OBJECT_SUBSTITUTION_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "OBJECT_SUBSTITUTION_PK" ON "OBJECT_SUBSTITUTION" ("APPLICATION_KEY", "ID")  ;
--------------------------------------------------------
--  Constraints for Table ACCOUNT
--------------------------------------------------------

  ALTER TABLE "ACCOUNT" MODIFY ("GROUP_ID" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT" ADD CONSTRAINT "APP_USER_PK" PRIMARY KEY ("APPLICATION_KEY", "USER_NAME");
  ALTER TABLE "ACCOUNT" MODIFY ("CREATE_DATE" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT" MODIFY ("ACTIVE" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT" MODIFY ("PASSWORD" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT" MODIFY ("USER_NAME" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT" MODIFY ("APPLICATION_KEY" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table ACCOUNT_INFO
--------------------------------------------------------

  ALTER TABLE "ACCOUNT_INFO" ADD CONSTRAINT "ACCOUNT_INFO_PK" PRIMARY KEY ("APPLICATION_KEY", "USER_NAME");
  ALTER TABLE "ACCOUNT_INFO" MODIFY ("IS_DELETED" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_INFO" MODIFY ("FAILED_ANSWER_ATTEMPT_DATE" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_INFO" MODIFY ("FAILED_ANSWER_ATTEMPT_COUNT" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_INFO" MODIFY ("FAILED_PASSWORD_ATTEMPT_DATE" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_INFO" MODIFY ("FAILED_PASSWORD_ATTEMPT_COUNT" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_INFO" MODIFY ("CREATE_UTC_DATE" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_INFO" MODIFY ("IS_LOCKEDOUT" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_INFO" MODIFY ("IS_APPROVED" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_INFO" MODIFY ("IS_ANONYMOUS" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_INFO" MODIFY ("USER_NAME" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_INFO" MODIFY ("APPLICATION_KEY" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table ACCOUNT_LOGON_AUDIT
--------------------------------------------------------

  ALTER TABLE "ACCOUNT_LOGON_AUDIT" MODIFY ("USER_NAME" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_LOGON_AUDIT" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_LOGON_AUDIT" MODIFY ("CLIENT_USER_NAME" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_LOGON_AUDIT" MODIFY ("CLIENT_MACHINE_NAME" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_LOGON_AUDIT" MODIFY ("CLIENT_IP_ADDRESS" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_LOGON_AUDIT" MODIFY ("FULLNAME_ENGLISH" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_LOGON_AUDIT" MODIFY ("CREATION_DATE" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table ACCOUNT_PASSWORD_AUDIT
--------------------------------------------------------

  ALTER TABLE "ACCOUNT_PASSWORD_AUDIT" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_PASSWORD_AUDIT" MODIFY ("USER_NAME" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_PASSWORD_AUDIT" MODIFY ("PASSWORD" NOT NULL ENABLE);
  ALTER TABLE "ACCOUNT_PASSWORD_AUDIT" ADD CONSTRAINT "ACCOUNT_PASSWORD_AUDIT_PK" PRIMARY KEY ("APPLICATION_KEY", "ID", "USER_NAME");
  ALTER TABLE "ACCOUNT_PASSWORD_AUDIT" MODIFY ("CREATION_DATE" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table APPLICATION
--------------------------------------------------------

  ALTER TABLE "APPLICATION" ADD CONSTRAINT "APPLICATION_PK" PRIMARY KEY ("APPLICATION_KEY");
  ALTER TABLE "APPLICATION" MODIFY ("NAME" NOT NULL ENABLE);
  ALTER TABLE "APPLICATION" MODIFY ("APPLICATION_KEY" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table APPLICATION_ACCOUNT_RULE
--------------------------------------------------------

  ALTER TABLE "APPLICATION_ACCOUNT_RULE" ADD CONSTRAINT "APPLICATION_ACCOUNT_RULE_PK" PRIMARY KEY ("APPLICATION_KEY", "USER_NAME", "OBJECT_ID", "RULE_ID");
  ALTER TABLE "APPLICATION_ACCOUNT_RULE" MODIFY ("OBJECT_ID" NOT NULL ENABLE);
  ALTER TABLE "APPLICATION_ACCOUNT_RULE" MODIFY ("USER_NAME" NOT NULL ENABLE);
  ALTER TABLE "APPLICATION_ACCOUNT_RULE" MODIFY ("RULE_ID" NOT NULL ENABLE);
  ALTER TABLE "APPLICATION_ACCOUNT_RULE" MODIFY ("APPLICATION_KEY" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table APPLICATION_GROUP
--------------------------------------------------------

  ALTER TABLE "APPLICATION_GROUP" ADD CONSTRAINT "APPLICATION_GROUP_PK" PRIMARY KEY ("APPLICATION_KEY", "GROUP_ID");
  ALTER TABLE "APPLICATION_GROUP" MODIFY ("GROUP_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table APPLICATION_GROUP_RULE
--------------------------------------------------------

  ALTER TABLE "APPLICATION_GROUP_RULE" ADD CONSTRAINT "APPLICATION_GROUP_RULE_PK" PRIMARY KEY ("APPLICATION_KEY", "GROUP_ID", "OBJECT_ID", "RULE_ID");
  ALTER TABLE "APPLICATION_GROUP_RULE" MODIFY ("OBJECT_ID" NOT NULL ENABLE);
  ALTER TABLE "APPLICATION_GROUP_RULE" MODIFY ("GROUP_ID" NOT NULL ENABLE);
  ALTER TABLE "APPLICATION_GROUP_RULE" MODIFY ("RULE_ID" NOT NULL ENABLE);
  ALTER TABLE "APPLICATION_GROUP_RULE" MODIFY ("APPLICATION_KEY" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table APPLICATION_OBJECT
--------------------------------------------------------

  ALTER TABLE "APPLICATION_OBJECT" ADD CONSTRAINT "APPLICATION_OBJECT_PKJECT_PK" PRIMARY KEY ("APPLICATION_KEY", "ID");
  ALTER TABLE "APPLICATION_OBJECT" MODIFY ("OBJECT_NAME_LOCAL" NOT NULL ENABLE);
  ALTER TABLE "APPLICATION_OBJECT" MODIFY ("OBJECT_NAME_ENGLISH" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table APPLICATION_RULE
--------------------------------------------------------

  ALTER TABLE "APPLICATION_RULE" ADD CONSTRAINT "SYS_RULE_PK" PRIMARY KEY ("APPLICATION_KEY", "RULE_ID");
  ALTER TABLE "APPLICATION_RULE" MODIFY ("RULE_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table DICTIONARY
--------------------------------------------------------

  ALTER TABLE "DICTIONARY" ADD CONSTRAINT "DICTIONARY_PK" PRIMARY KEY ("APPLICATION_KEY", "KEY");
  ALTER TABLE "DICTIONARY" MODIFY ("CREATION_DATE" NOT NULL ENABLE);
  ALTER TABLE "DICTIONARY" MODIFY ("KEY" NOT NULL ENABLE);
  ALTER TABLE "DICTIONARY" MODIFY ("APPLICATION_KEY" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table OBJECT_SUBSTITUTION
--------------------------------------------------------

  ALTER TABLE "OBJECT_SUBSTITUTION" MODIFY ("ID" NOT NULL ENABLE);
  ALTER TABLE "OBJECT_SUBSTITUTION" MODIFY ("OBJECT_ID" NOT NULL ENABLE);
